<?php return array (
  0 => 'CREATE TABLE `xiaozu_shop` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `uid` int(20) NOT NULL COMMENT \'用户ID\',
  `shortname` varchar(10) DEFAULT NULL COMMENT \'店铺短地址\',
  `shopname` varchar(150) NOT NULL COMMENT \'店铺名称\',
  `shoplogo` varchar(150) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL COMMENT \'联系电话\',
  `address` varchar(150) DEFAULT NULL COMMENT \'联系地址\',
  `point` int(10) NOT NULL DEFAULT \'5\' COMMENT \'评分\',
  `cx_info` text COMMENT \'促销信息\',
  `intr_info` text COMMENT \'介绍信息\',
  `notice_info` text COMMENT \'公告信息\',
  `starttime` varchar(100) DEFAULT NULL COMMENT \'营业时间\',
  `is_open` int(1) NOT NULL DEFAULT \'0\' COMMENT \'是否营业\',
  `is_onlinepay` int(1) NOT NULL DEFAULT \'1\' COMMENT \'是否开启在线支付：默认为1开启，0不开启\',
  `is_daopay` int(1) NOT NULL DEFAULT \'1\' COMMENT \'是否开启到付：默认为1开启，0不开启\',
  `is_pass` int(1) NOT NULL DEFAULT \'0\' COMMENT \'是否通过审核\',
  `is_recom` int(1) NOT NULL DEFAULT \'0\' COMMENT \'是否是推荐店铺\',
  `maphone` varchar(12) DEFAULT NULL,
  `addtime` int(12) DEFAULT NULL,
  `pointcount` int(5) NOT NULL DEFAULT \'0\',
  `psservicepoint` int(11) NOT NULL COMMENT \'配送服务评分\',
  `psservicepointcount` int(11) NOT NULL COMMENT \'配送服务评论次数\',
  `yjin` decimal(5,2) NOT NULL DEFAULT \'0.00\' COMMENT \'佣金比例当为0时调用网站设置\',
  `lat` decimal(9,6) NOT NULL DEFAULT \'0.000000\' COMMENT \'地图左坐标\',
  `lng` decimal(9,6) NOT NULL DEFAULT \'0.000000\' COMMENT \'地图右坐标\',
  `shopbacklogo` varchar(255) DEFAULT NULL COMMENT \'商家默认背景图片\',
  `sort` int(20) NOT NULL DEFAULT \'999\' COMMENT \'排序\',
  `email` varchar(50) DEFAULT NULL,
  `areaid1` int(20) NOT NULL DEFAULT \'0\',
  `areaid2` int(20) NOT NULL DEFAULT \'0\',
  `areaid3` int(20) NOT NULL DEFAULT \'0\',
  `otherlink` varchar(255) DEFAULT NULL COMMENT \'其他链接地址\',
  `endtime` int(11) NOT NULL DEFAULT \'0\',
  `IMEI` varchar(255) DEFAULT NULL,
  `shoptype` int(2) NOT NULL DEFAULT \'0\',
  `noticetype` varchar(100) DEFAULT NULL,
  `machine_code` varchar(255) DEFAULT NULL COMMENT \'打印2机器码\',
  `mKey` varchar(255) DEFAULT NULL COMMENT \'打印2打印密匙\',
  `pradiusa` int(1) NOT NULL DEFAULT \'1\',
  `admin_id` int(20) NOT NULL DEFAULT \'0\',
  `sellcount` int(10) DEFAULT \'0\',
  `goodattrdefault` varchar(25) NOT NULL,
  `ruzhutype` int(11) NOT NULL DEFAULT \'0\',
  `qiyeimg` varchar(150) NOT NULL,
  `zmimg` varchar(150) NOT NULL,
  `fmimg` varchar(150) NOT NULL,
  `foodtongimg` varchar(150) DEFAULT NULL,
  `jkzimg` varchar(150) DEFAULT NULL,
  `sqimg` varchar(150) DEFAULT NULL,
  `qtshuoming` varchar(255) DEFAULT NULL,
  `wxhui_ewmurl` text NOT NULL COMMENT \'闪惠制作二维码url\',
  `goodlistmodule` int(1) NOT NULL DEFAULT \'0\' COMMENT \'商品列表模板默认为0   \',
  `shoplicense` varchar(150) NOT NULL COMMENT \'营业执照\',
  `virtualsellcounts` int(11) DEFAULT NULL COMMENT \'店铺虚拟总销量\',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=207 DEFAULT CHARSET=utf8',
  1 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'4\',\'4\',\'\',\'新区美格美得百货商行\',\'/upload/user/20160109232216756.jpg\',\'18626399930\',\'无锡\',\'35\',\'\',\'恭喜发财fdsfdfsfsdfdsf\',\'本店为测试店，请勿购买！———切记\',\'07:00-23:54\',\'1\',\'1\',\'1\',\'1\',\'1\',\'18626399930\',\'1433149257\',\'7\',\'31\',\'7\',\'5.00\',\'31.563956\',\'120.369449\',\'\',\'1\',\'970268691@qq.com\',\'0\',\'0\',\'0\',\'\',\'2147483647\',\'\',\'0\',\'1,2,3\',\'\',\'\',\'30\',\'0\',\'448\',\'件\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'http://weixin.qq.com/q/jjr-v-blcgQLidMN6hIp\',\'0\',\'\',\'\')',
  2 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'190\',\'2955\',\'heshe\',\'合硕厨卫电器\',\'/upload/user/20160416225805987.png\',\'13391106993\',\'青海省地址：西宁市城东区互助路小商品市场2期2楼45号\',\'5\',\'\',\'\',\'\',\'08:30-11:59|12:00-18:30\',\'1\',\'1\',\'1\',\'1\',\'1\',\'13391106993\',\'1460466166\',\'1\',\'5\',\'1\',\'0.00\',\'36.619091\',\'101.826368\',\'\',\'999\',\'wzhysp@126.com\',\'0\',\'0\',\'0\',\'\',\'1486441471\',\'\',\'1\',\'\',\'\',\'\',\'0\',\'90\',\'0\',\'台\',\'1\',\'/upload/goods/20160412210120913.jpg\',\'/upload/goods/20160412210138167.jpg\',\'/upload/goods/20160412210202666.jpg\',\'/upload/goods/20160412210243738.jpg\',\'\',\'\',\'\',\'\',\'1\',\'\',\'\')',
  3 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'103\',\'1112\',\'\',\'超市旗舰店\',\'/upload/user/20160729080121551.png\',\'15022222222\',\'江海路16号\',\'5\',\'\',\'\',\'持续升级永无止境！\',\'00:07-21:59\',\'1\',\'1\',\'1\',\'1\',\'1\',\'15555554444\',\'1442311583\',\'1\',\'5\',\'1\',\'5.00\',\'31.564909\',\'120.366960\',\'\',\'2\',\'56465@qq.com\',\'0\',\'0\',\'0\',\'\',\'1521199407\',\'\',\'1\',\'1,3\',\'\',\'\',\'3\',\'0\',\'42\',\'份\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\',\'\')',
  4 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'198\',\'2970\',\'nxy\',\'鸿运超市\',\'\',\'13771482868\',\'硕放镇南星苑菜市场\',\'5\',\'\',\'\',\'\',\'7:00-11:59|12:00-9:30\',\'1\',\'1\',\'1\',\'1\',\'0\',\'13921512466\',\'1461555244\',\'1\',\'5\',\'1\',\'0.00\',\'31.476969\',\'120.444086\',\'\',\'999\',\'12345@qq.com\',\'0\',\'0\',\'0\',\'\',\'1493091244\',\'\',\'1\',\'\',\'\',\'\',\'3\',\'0\',\'0\',\'个\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\',\'\')',
  5 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'196\',\'2964\',\'xycs\',\'无锡职教园办事处\',\'/upload/user/20160513120420408.png\',\'18626399933\',\'无锡市职教园\',\'5\',\'\',\'\',\'\',\'7:30-12:00|12:01-23:00\',\'1\',\'1\',\'1\',\'1\',\'1\',\'18626399933\',\'1460888444\',\'1\',\'5\',\'1\',\'0.00\',\'31.588621\',\'120.195192\',\'\',\'999\',\'563096011@qq.com\',\'0\',\'0\',\'0\',\'\',\'1492424444\',\'\',\'1\',\'1,3\',\'\',\'\',\'5\',\'0\',\'0\',\'份\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\',\'\')',
  6 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'205\',\'2984\',\'\',\'蛋糕坊1\',\'\',\'13023310322\',\'adcv\',\'5\',\'\',\'\',\'\',\'00:07-21:00\',\'1\',\'1\',\'1\',\'1\',\'1\',\'13903833232\',\'1467618464\',\'1\',\'5\',\'1\',\'0.00\',\'31.563110\',\'120.367560\',\'\',\'3\',\'2441612314@qq.com\',\'0\',\'0\',\'0\',\'\',\'1499154464\',\'\',\'0\',\'\',\'\',\'\',\'3\',\'0\',\'0\',\'个\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'0\',\'\',\'\')',
  7 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'204\',\'2983\',\'\',\'蛋糕坊\',\'\',\'\',\'\',\'5\',\'\',\'\',\'\',\'\',\'0\',\'1\',\'1\',\'1\',\'0\',\'13903833233\',\'1467613263\',\'1\',\'5\',\'1\',\'0.00\',\'0.000000\',\'0.000000\',\'\',\'4\',\'2441612324@qq.com\',\'0\',\'0\',\'0\',\'\',\'1499149263\',\'\',\'0\',\'\',\'\',\'\',\'1\',\'0\',\'0\',\'\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'0\',\'\',\'\')',
  8 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'203\',\'2980\',\'\',\'一家超市\',\'/upload/user/20160828225430965.png\',\'13771420656\',\'新苑路10号\',\'5\',\'\',\'一家超市，前身为洛社镇公园路“凤娥百货店”，自1999年至今，秉承优惠、高质、诚信、热情的经营理念，视顾客为朋友，深受广大市民熟知。从2014年经转型升级，本店铺搬迁至洛社镇新苑菜场西侧。一家超市为了更好地服务广大顾客朋友，也加入了互联网 的大浪潮，让广大顾客朋友购物更加轻松、便捷。希望新老顾客朋友一如既往的支持与指导。\',\'本超市，大米、粮油、香烟、鸡蛋不单独配送，请谅解。\',\'06:15-23:00\',\'1\',\'1\',\'1\',\'1\',\'0\',\'13771420656\',\'1464313222\',\'1\',\'5\',\'1\',\'0.00\',\'31.659522\',\'120.181287\',\'\',\'999\',\'2461669776@qq.com\',\'0\',\'0\',\'0\',\'\',\'1495849222\',\'\',\'1\',\'2,3\',\'\',\'\',\'2\',\'0\',\'0\',\'个\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'1\',\'\',\'986\')',
  9 => 'INSERT INTO `xiaozu_shop`(`id`,`uid`,`shortname`,`shopname`,`shoplogo`,`phone`,`address`,`point`,`cx_info`,`intr_info`,`notice_info`,`starttime`,`is_open`,`is_onlinepay`,`is_daopay`,`is_pass`,`is_recom`,`maphone`,`addtime`,`pointcount`,`psservicepoint`,`psservicepointcount`,`yjin`,`lat`,`lng`,`shopbacklogo`,`sort`,`email`,`areaid1`,`areaid2`,`areaid3`,`otherlink`,`endtime`,`IMEI`,`shoptype`,`noticetype`,`machine_code`,`mKey`,`pradiusa`,`admin_id`,`sellcount`,`goodattrdefault`,`ruzhutype`,`qiyeimg`,`zmimg`,`fmimg`,`foodtongimg`,`jkzimg`,`sqimg`,`qtshuoming`,`wxhui_ewmurl`,`goodlistmodule`,`shoplicense`,`virtualsellcounts`) VALUES(\'206\',\'3008\',\'\',\'酒店用品配送\',\'\',\'\',\'恵山区洛社镇健康路15-9号\',\'5\',\'\',\'\',\'\',\'\',\'0\',\'1\',\'1\',\'0\',\'0\',\'15716188756\',\'1473837302\',\'0\',\'0\',\'0\',\'0.00\',\'0.000000\',\'0.000000\',\'\',\'999\',\'\',\'0\',\'0\',\'0\',\'\',\'1505373302\',\'\',\'1\',\'\',\'\',\'\',\'1\',\'0\',\'0\',\'\',\'0\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'0\',\'\',\'\')',
)?>